2013-05-02 - 4674.1200 - Rel Notes - BI Reports Issues - Release 019 #BIReleases2013

Release Notes:

4674.1200 - BI Reports Issues - SA140


Admin Info

Purpose
 To fix the issues in BOBI 4.0 Production server
Release No
 019
Submitted
 05-02-2013
Submitted by
 MallaReddy
Source/Destination Systems
 IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
Release Sent To
 Mark Harris
Object(s) Created By
 Naga Brahmam
Object(s) Tested By
 Naga Brahmam

Report Name

SA140 - License Scorecard

Name of the Queries

ZMP_SA_OO_Q025
ZMP_SA_OO_Q026
ZMP_SA_OO_Q027
ZMP_SA_OO_Q028
ZMP_SA_OO_Q029
ZMP_SA_OO_Q030
ZMP_SA_OO_Q031
ZMP_SA_OO_Q032
ZMP_SA_OO_Q033
ZSDC_SSL_Q007

NEC Crystal Reports Standards Check

1. SA140 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. SA140 NEC CR checklist has been sent to NEC and also attached here for reference:
SA140 NEC CR Standard Check List.xlsx

Summary Level Check

Test Conducted

Grouping 1 : EMEA > EMEA Sales > ARSENAL > YTD
SNo
 Test Case
 Value in BO 3.1 Report
 Value in BI 4.0 Report
 Pass/Fail
1
 Current Year Shipped YTD
 0
 0
 Pass
2
 Total Open Revenue
 0
 0
 Pass
3
 Total Shipped Current Year
 0
 0
 Pass
4
 Total Shipped Last Year
 4,130
 4,130
 Pass
5
 Last Year Shipped%
 0%
 0%
 Pass
6
 Last Year Total%
 0%
 0%
 Pass

Grouping 2 : North America > 5th & OCEAN SALES > NON LICENSED > YTD
SNo
 Test Case
 Value in BO 3.1 Report
 Value in BI 4.0 Report
 Pass/Fail
1
 Current Year Shipped YTD
 78,253
 78,253
 Pass
2
 Total Open Revenue
 18,153
 18,153
 Pass
3
 Total Shipped Current Year
 96,406
 96,406
 Pass
4
 Total Shipped Last Year
 253,775
 253,775
 Pass
5
 Last Year Shipped%
 31%
 31%
 Pass
6
 Last Year Total%
 38%
 38%
 Pass

HotMarkets Sub Report Validation

‍Test Conducted

Grouping 1: EMEA > EMEA Sales > DISNEY > YTD
SNo
 Test Case
 Value in BO 3.1 Report
 Value in BI 4.0 Report
 Pass/Fail
1
 Current Year Shipped YTD
 -
 -
 Pass
2
 Total Open Revenue
 -
 -
 Pass
3
 Total Shipped Current Year
 -
 -
 Pass
4
 Total Shipped Last Year
 -
 -
 Pass
5
 Last Year Shipped%
 -
 -
 Pass
6
 Last Year Total%
 -
 -
 Pass

Grouping 2: North America> Canada Sales > NBA PROPERTIES > YTD
SNo
 Test Case
 Value in BO 3.1 Report
 Value in BI 4.0 Report
 Pass/Fail
1
 Current Year Shipped YTD
 2,168
 2,168
 Pass
2
 Total Open Revenue
 31,461
 31,461
 Pass
3
 Total Shipped Current Year
 33,629
 33,629
 Pass
4
 Total Shipped Last Year
 0
 0
 Pass
5
 Last Year Shipped%
 0%
 0%
 Pass
6
 Last Year Total%
 0%
 0%
 Pass

Shipped_Product_Collection Sub Report Validation

‍Test Conducted

Grouping 1: EMEA > EMEA Sales > MARVEL CHARACTERS > TEAM HERO SNAP
SNo
 Test Case
 Value in BO 3.1 Report
 Value in BI 4.0 Report
 Pass/Fail
1
 Current Year Quantity
 2,282
 2,282
 Pass
2
 Current Year Revenue
 35,107
 35,107
 Pass
3
 Last Year Quantity
 24
 24
 Pass
4
 Last Year Revenue
 271
 271
 Pass

Grouping 2: North America > United States Sales > BASEBALL HALL OF FAME > CUSTOM
SNo
 Test Case
 Value in BO 3.1 Report
 Value in BI 4.0 Report
 Pass/Fail
1
 Current Year Quantity
 384
 384
 Pass
2
 Current Year Revenue
 4,082
 4,082
 Pass
3
 Last Year Quantity
 1,455
 1,455
 Pass
4
 Last Year Revenue
 14,235
 14,235
 Pass

Open_ Product_Collection Sub Report Validation

‍Test Conducted

Grouping 1: EMEA > EMEA Sales > NEW ERA BRANDED > NE ORIG CUFF KNIT 3
SNo
 Test Case
 Value in BO 3.1 Report
 Value in BI 4.0 Report
 Pass/Fail
1
 Current Year Quantity
 9,720
 9,720
 Pass
2
 Current Year Revenue
 69,216
 69,216
 Pass
3
 Last Year Quantity
 0
 0
 Pass
4
 Last Year Revenue
 0
 0
 Pass

Grouping 2: North America > United States Sales > EA SPORTS > HeadWear
SNo
 Test Case
 Value in BO 3.1 Report
 Value in BI 4.0 Report
 Pass/Fail
1
 Current Year Quantity
 1,897
 1,897
 Pass
2
 Current Year Revenue
 21,606
 21,606
 Pass
3
 Last Year Quantity
 0
 0
 Pass
4
 Last Year Revenue
 0
 0
 Pass

Shipped_Customer Sub Report Validation

‍Test Conducted

Grouping 1: EMEA > German Sales > MLB PROPERTIES > Galeria Kaufhof Gmbh
SNo
 Test Case
 Value in BO 3.1 Report
 Value in BI 4.0 Report
 Pass/Fail
1
 Current Year Quantity
 4,845
 4,845
 Pass
2
 Current Year Revenue
 58,213
 58,213
 Pass
3
 Last Year Quantity
 25,455
 25,455
 Pass
4
 Last Year Revenue
 253,629
 253,629
 Pass

Grouping 2: North America > United States Sales > MTV > Ace Accessory Inc
SNo
 Test Case
 Value in BO 3.1 Report
 Value in BI 4.0 Report
 Pass/Fail
1
 Current Year Quantity
 192
 192
 Pass
2
 Current Year Revenue
 2,333
 2,333
 Pass
3
 Last Year Quantity
 360
 360
 Pass
4
 Last Year Revenue
 5,037
 5,037
 Pass

Shipped_Open Sub Report Validation

‍Test Conducted

Grouping 1: EMEA > German Sales > NFL PROPERTIES
SNo
 Test Case
 Value in BO 3.1 Report
 Value in BI 4.0 Report
 Pass/Fail
1
 Current Year Quantity
 -
 -
 Pass
2
 Current Year Revenue
 -
 -
 Pass
3
 Last Year Quantity
 -
 -
 Pass
4
 Last Year Revenue
 -
 -
 Pass

Grouping 2: North America > United States Sales > WORLD BASEBALL CLASSIC > Miami Marlins Merchadising
SNo
 Test Case
 Value in BO 3.1 Report
 Value in BI 4.0 Report
 Pass/Fail
1
 Current Year Quantity
 -16
 -16
 Pass
2
 Current Year Revenue
 -224
 -224
 Pass
3
 Last Year Quantity
 479
 479
 Pass
4
 Last Year Revenue
 6,720
 6,720
 Pass

Service Level Sub Report Validation

‍Test Conducted

Grouping 1: EMEA > GERMAN Sales > NEW ERA BRANDED > Ordered Fill Rate
SNo
 Test Case
 Value in BO 3.1 Report
 Value in BI 4.0 Report
 Pass/Fail
1
 Current Year (2013)
 100%
 100%
 Pass
2
 Last Year (2012)
 95%
 95%
 Pass

Grouping 2: North America > United States Sales > USA BASEBALL > Confirmed Ontime
SNo
 Test Case
 Value in BO 3.1 Report
 Value in BI 4.0 Report
 Pass/Fail
1
 Current Year (2013)
 60%
 60%
 Pass
2
 Last Year (2012)
 87%
 87%
 Pass

Reference Document(Specification)

2013-04-18 - 4674.1200 - Spec - BI Reports Issues